﻿
namespace LibMS.Models
{
    public class StringConstant
    {
        //Table name
        public const string TABLE_LIBCATEGORIES = "LibCategories";
        public const string TABLE_LIBDOCUMENTS = "LibDocuments";
        public const string TABLE_LIBRACK = "LibRack";
        public const string TABLE_LIBUPLOADDATA = "LibUploadData";
        public const string TABLE_LIBBORROWDOCUMENT = "LibBorrowDocument";
        public const string TABLE_LIBREADER = "LibReader";
        public const string TABLE_LIBROLE = "LibRole";
        public const string TABLE_CMSUSER = "CmsUser";
        public const string TABLE_LIBUSERROLE = "LibUserRole";

        //Base sp name
        public const string SP_BASE_GET = "_Get";
        public const string SP_BASE_GET_BYID = "_GetById";
        public const string SP_BASE_CREATE = "_Create";
        public const string SP_BASE_UPDATE = "_Update";
        public const string SP_BASE_DELETE = "_Delete";
        public const string SP_BASE_FIND = "_Find";

        //LibDocuments
        public const string SP_LIBDOCUMENTS_GETFILEUPLOAD = "_GetFileUpload";
        public const string SP_LIBDOCUMENTS_GETBYCATEGORYID = "_GetByCategoryId";
        public const string SP_LIBDOCUMENTS_GETTOP5BYCATEGORYID = "_GetTop5ByCategoryId";
        public const string SP_LIBDOCUMENTS_GETTOP5NEW = "_GetTop5New";
        public const string SP_LIBDOCUMENTS_GETTOP5VIEW = "_GetTop5ViewCount";
        public const string SP_LIBDOCUMENTS_GETBYRACKID = "_GetByRackId";
        public const string SP_LIBDOCUMENTS_SEARCHONECONDITION = "_Search1Condition";
        public const string SP_LIBDOCUMENTS_SEARCHTOP10BY1CONDITION = "_SearchTop10By1Condition";
        public const string SP_LIBDOCUMENTS_GETTOTALCURRENTDOCUMENT = "_GetTotalCurrentDocument";

        //LibBorrowDocument
        public const string SP_LIBBORROWDOCUMENT_RETURNDOCUMENT = "_ReturnDocument";

        //LibCategories
        public const string SP_LIBCATEGPRIES_GET_LV0 = "_Get_Lv0";

        //LibRole
        public const string SP_LIBROLE_GETUSERROLE = "_GetUserRole";

        //LibUploadData

        //cms_User
        public const string SP_CMSUSER_LOGIN = "_Login";
        public const string SP_CMSUSER_USERINROLE = "_UserInRole";
        public const string SP_CMSUSER_GETUSERIDBYUSERNAME = "_GetUserIdByUsername";
        public const string SP_CMSUSER_GETUSERBYUSERNAME = "_GetByUserName";

        //LibUserRole
        public const string SP_LIBUSERROLE_UPDATEROLEFORUSER = "_UpdateRoleForUser";
    }
}